package fr.enseirb.mycub.db;

import android.provider.BaseColumns;

public class BusDBConstants extends DBConstants{

	// tables pour les bus
	public static final String BUS_STATION_TABLE = "bus_stations";
	public static final String LINK_LINE_STATION_TABLE = "link_line_bus_station";
	public static final String LINE_TABLE = "busLineTable";
	public static final String SPECIFIC_LINE_TABLE = "busSpecificLineTable";

	public static final String KEY_SPECIFIC_LINE_ID = "specificLineId";
	public static final String KEY_STATION_ID = "stationId";

	public static final String CREATE_STATIONS_TABLE = "create table " + BUS_STATION_TABLE
			+" (" + BaseColumns._ID + " integer not null, "
			+ KEY_NAME + " text not null COLLATE NOCASE, "
			+ KEY_OPEN + " integer not null, "
			+ KEY_ADDRESS + " text not null COLLATE NOCASE, "
			+ KEY_LATITUDE + " integer not null, "
			+ KEY_LONGITUDE + " integer not null, "
			+ KEY_FAVORITE + " integer not null );";


	public static final String CREATE_LINK_LINE_STATION = "create table "+ LINK_LINE_STATION_TABLE
			+" (" + KEY_SPECIFIC_LINE_ID + " integer not null, "
			+ KEY_STATION_ID +" integer not null );";
	
	public static final String CREATE_LINE_TABLE = "create table "+ LINE_TABLE 
			+ " (" + BaseColumns._ID + " integer not null, "
			+ KEY_NAME + " text not null COLLATE NOCASE, "
			+ KEY_TYPE + " integer not null);";
			
	
	public static final String CREATE_SPECIFIC_LINE_TABLE = "create table "+ SPECIFIC_LINE_TABLE
			+ " (" + BaseColumns._ID + " integer not null, "
			+ KEY_NAME + " text not null COLLATE NOCASE, "
			+ KEY_LINE_ID + " integer not null, "
			+ KEY_STATION_START_ID + " integer not null, "
			+ KEY_STATION_END_ID + " integer not null);";

}